package com.itic.mall.system.goods.goodshotjd.persistence.model;

import com.itic.appbase.framework.common.persistence.model.BaseExample;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class GoodsHotJdExample extends BaseExample {
    /**
    
     *
     * @mbggenerated
     */
    protected String orderByClause;

    /**
    
     *
     * @mbggenerated
     */
    protected boolean distinct;

    /**
    
     *
     * @mbggenerated
     */
    protected List<Criteria> oredCriteria;

    /**
    
     *
     * @mbggenerated
     */
    public GoodsHotJdExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
    
     *
     * @mbggenerated
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
    
     *
     * @mbggenerated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
    
     *
     * @mbggenerated
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
    
     *
     * @mbggenerated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
    
     *
     * @mbggenerated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
    
     *
     * @mbggenerated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
    
     *
     * @mbggenerated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * This class corresponds to the database table t_goods_hot_jd
     *
     * @mbggenerated
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveIsNull() {
            addCriterion("IS_EFFECTIVE is null");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveIsNotNull() {
            addCriterion("IS_EFFECTIVE is not null");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveEqualTo(String value) {
            addCriterion("IS_EFFECTIVE =", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotEqualTo(String value) {
            addCriterion("IS_EFFECTIVE <>", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveGreaterThan(String value) {
            addCriterion("IS_EFFECTIVE >", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveGreaterThanOrEqualTo(String value) {
            addCriterion("IS_EFFECTIVE >=", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveLessThan(String value) {
            addCriterion("IS_EFFECTIVE <", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveLessThanOrEqualTo(String value) {
            addCriterion("IS_EFFECTIVE <=", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveLike(String value) {
            addCriterion("IS_EFFECTIVE like", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotLike(String value) {
            addCriterion("IS_EFFECTIVE not like", value, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveIn(List<String> values) {
            addCriterion("IS_EFFECTIVE in", values, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotIn(List<String> values) {
            addCriterion("IS_EFFECTIVE not in", values, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveBetween(String value1, String value2) {
            addCriterion("IS_EFFECTIVE between", value1, value2, "isEffective");
            return (Criteria) this;
        }

        public Criteria andIsEffectiveNotBetween(String value1, String value2) {
            addCriterion("IS_EFFECTIVE not between", value1, value2, "isEffective");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIsNull() {
            addCriterion("ORG_CODE is null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIsNotNull() {
            addCriterion("ORG_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andOrgCodeEqualTo(String value) {
            addCriterion("ORG_CODE =", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotEqualTo(String value) {
            addCriterion("ORG_CODE <>", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeGreaterThan(String value) {
            addCriterion("ORG_CODE >", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ORG_CODE >=", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLessThan(String value) {
            addCriterion("ORG_CODE <", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLessThanOrEqualTo(String value) {
            addCriterion("ORG_CODE <=", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeLike(String value) {
            addCriterion("ORG_CODE like", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotLike(String value) {
            addCriterion("ORG_CODE not like", value, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeIn(List<String> values) {
            addCriterion("ORG_CODE in", values, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotIn(List<String> values) {
            addCriterion("ORG_CODE not in", values, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeBetween(String value1, String value2) {
            addCriterion("ORG_CODE between", value1, value2, "orgCode");
            return (Criteria) this;
        }

        public Criteria andOrgCodeNotBetween(String value1, String value2) {
            addCriterion("ORG_CODE not between", value1, value2, "orgCode");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("CREATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("CREATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("CREATE_USER =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("CREATE_USER <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("CREATE_USER >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("CREATE_USER <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("CREATE_USER like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("CREATE_USER not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("CREATE_USER in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("CREATE_USER not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("CREATE_USER between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andReorderIsNull() {
            addCriterion("REORDER is null");
            return (Criteria) this;
        }

        public Criteria andReorderIsNotNull() {
            addCriterion("REORDER is not null");
            return (Criteria) this;
        }

        public Criteria andReorderEqualTo(Integer value) {
            addCriterion("REORDER =", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderNotEqualTo(Integer value) {
            addCriterion("REORDER <>", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderGreaterThan(Integer value) {
            addCriterion("REORDER >", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderGreaterThanOrEqualTo(Integer value) {
            addCriterion("REORDER >=", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderLessThan(Integer value) {
            addCriterion("REORDER <", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderLessThanOrEqualTo(Integer value) {
            addCriterion("REORDER <=", value, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderIn(List<Integer> values) {
            addCriterion("REORDER in", values, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderNotIn(List<Integer> values) {
            addCriterion("REORDER not in", values, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderBetween(Integer value1, Integer value2) {
            addCriterion("REORDER between", value1, value2, "reorder");
            return (Criteria) this;
        }

        public Criteria andReorderNotBetween(Integer value1, Integer value2) {
            addCriterion("REORDER not between", value1, value2, "reorder");
            return (Criteria) this;
        }

        public Criteria andNoteIsNull() {
            addCriterion("NOTE is null");
            return (Criteria) this;
        }

        public Criteria andNoteIsNotNull() {
            addCriterion("NOTE is not null");
            return (Criteria) this;
        }

        public Criteria andNoteEqualTo(String value) {
            addCriterion("NOTE =", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotEqualTo(String value) {
            addCriterion("NOTE <>", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThan(String value) {
            addCriterion("NOTE >", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThanOrEqualTo(String value) {
            addCriterion("NOTE >=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThan(String value) {
            addCriterion("NOTE <", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThanOrEqualTo(String value) {
            addCriterion("NOTE <=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLike(String value) {
            addCriterion("NOTE like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotLike(String value) {
            addCriterion("NOTE not like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteIn(List<String> values) {
            addCriterion("NOTE in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotIn(List<String> values) {
            addCriterion("NOTE not in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteBetween(String value1, String value2) {
            addCriterion("NOTE between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotBetween(String value1, String value2) {
            addCriterion("NOTE not between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andAdownerIsNull() {
            addCriterion("ADOWNER is null");
            return (Criteria) this;
        }

        public Criteria andAdownerIsNotNull() {
            addCriterion("ADOWNER is not null");
            return (Criteria) this;
        }

        public Criteria andAdownerEqualTo(String value) {
            addCriterion("ADOWNER =", value, "adowner");
            return (Criteria) this;
        }

        public Criteria andAdownerNotEqualTo(String value) {
            addCriterion("ADOWNER <>", value, "adowner");
            return (Criteria) this;
        }

        public Criteria andAdownerGreaterThan(String value) {
            addCriterion("ADOWNER >", value, "adowner");
            return (Criteria) this;
        }

        public Criteria andAdownerGreaterThanOrEqualTo(String value) {
            addCriterion("ADOWNER >=", value, "adowner");
            return (Criteria) this;
        }

        public Criteria andAdownerLessThan(String value) {
            addCriterion("ADOWNER <", value, "adowner");
            return (Criteria) this;
        }

        public Criteria andAdownerLessThanOrEqualTo(String value) {
            addCriterion("ADOWNER <=", value, "adowner");
            return (Criteria) this;
        }

        public Criteria andAdownerLike(String value) {
            addCriterion("ADOWNER like", value, "adowner");
            return (Criteria) this;
        }

        public Criteria andAdownerNotLike(String value) {
            addCriterion("ADOWNER not like", value, "adowner");
            return (Criteria) this;
        }

        public Criteria andAdownerIn(List<String> values) {
            addCriterion("ADOWNER in", values, "adowner");
            return (Criteria) this;
        }

        public Criteria andAdownerNotIn(List<String> values) {
            addCriterion("ADOWNER not in", values, "adowner");
            return (Criteria) this;
        }

        public Criteria andAdownerBetween(String value1, String value2) {
            addCriterion("ADOWNER between", value1, value2, "adowner");
            return (Criteria) this;
        }

        public Criteria andAdownerNotBetween(String value1, String value2) {
            addCriterion("ADOWNER not between", value1, value2, "adowner");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNull() {
            addCriterion("COMMISSION is null");
            return (Criteria) this;
        }

        public Criteria andCommissionIsNotNull() {
            addCriterion("COMMISSION is not null");
            return (Criteria) this;
        }

        public Criteria andCommissionEqualTo(Double value) {
            addCriterion("COMMISSION =", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotEqualTo(Double value) {
            addCriterion("COMMISSION <>", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThan(Double value) {
            addCriterion("COMMISSION >", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionGreaterThanOrEqualTo(Double value) {
            addCriterion("COMMISSION >=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThan(Double value) {
            addCriterion("COMMISSION <", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionLessThanOrEqualTo(Double value) {
            addCriterion("COMMISSION <=", value, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionIn(List<Double> values) {
            addCriterion("COMMISSION in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotIn(List<Double> values) {
            addCriterion("COMMISSION not in", values, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionBetween(Double value1, Double value2) {
            addCriterion("COMMISSION between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andCommissionNotBetween(Double value1, Double value2) {
            addCriterion("COMMISSION not between", value1, value2, "commission");
            return (Criteria) this;
        }

        public Criteria andCouponNoteIsNull() {
            addCriterion("COUPON_NOTE is null");
            return (Criteria) this;
        }

        public Criteria andCouponNoteIsNotNull() {
            addCriterion("COUPON_NOTE is not null");
            return (Criteria) this;
        }

        public Criteria andCouponNoteEqualTo(String value) {
            addCriterion("COUPON_NOTE =", value, "couponNote");
            return (Criteria) this;
        }

        public Criteria andCouponNoteNotEqualTo(String value) {
            addCriterion("COUPON_NOTE <>", value, "couponNote");
            return (Criteria) this;
        }

        public Criteria andCouponNoteGreaterThan(String value) {
            addCriterion("COUPON_NOTE >", value, "couponNote");
            return (Criteria) this;
        }

        public Criteria andCouponNoteGreaterThanOrEqualTo(String value) {
            addCriterion("COUPON_NOTE >=", value, "couponNote");
            return (Criteria) this;
        }

        public Criteria andCouponNoteLessThan(String value) {
            addCriterion("COUPON_NOTE <", value, "couponNote");
            return (Criteria) this;
        }

        public Criteria andCouponNoteLessThanOrEqualTo(String value) {
            addCriterion("COUPON_NOTE <=", value, "couponNote");
            return (Criteria) this;
        }

        public Criteria andCouponNoteLike(String value) {
            addCriterion("COUPON_NOTE like", value, "couponNote");
            return (Criteria) this;
        }

        public Criteria andCouponNoteNotLike(String value) {
            addCriterion("COUPON_NOTE not like", value, "couponNote");
            return (Criteria) this;
        }

        public Criteria andCouponNoteIn(List<String> values) {
            addCriterion("COUPON_NOTE in", values, "couponNote");
            return (Criteria) this;
        }

        public Criteria andCouponNoteNotIn(List<String> values) {
            addCriterion("COUPON_NOTE not in", values, "couponNote");
            return (Criteria) this;
        }

        public Criteria andCouponNoteBetween(String value1, String value2) {
            addCriterion("COUPON_NOTE between", value1, value2, "couponNote");
            return (Criteria) this;
        }

        public Criteria andCouponNoteNotBetween(String value1, String value2) {
            addCriterion("COUPON_NOTE not between", value1, value2, "couponNote");
            return (Criteria) this;
        }

        public Criteria andCouponTabIsNull() {
            addCriterion("COUPON_TAB is null");
            return (Criteria) this;
        }

        public Criteria andCouponTabIsNotNull() {
            addCriterion("COUPON_TAB is not null");
            return (Criteria) this;
        }

        public Criteria andCouponTabEqualTo(String value) {
            addCriterion("COUPON_TAB =", value, "couponTab");
            return (Criteria) this;
        }

        public Criteria andCouponTabNotEqualTo(String value) {
            addCriterion("COUPON_TAB <>", value, "couponTab");
            return (Criteria) this;
        }

        public Criteria andCouponTabGreaterThan(String value) {
            addCriterion("COUPON_TAB >", value, "couponTab");
            return (Criteria) this;
        }

        public Criteria andCouponTabGreaterThanOrEqualTo(String value) {
            addCriterion("COUPON_TAB >=", value, "couponTab");
            return (Criteria) this;
        }

        public Criteria andCouponTabLessThan(String value) {
            addCriterion("COUPON_TAB <", value, "couponTab");
            return (Criteria) this;
        }

        public Criteria andCouponTabLessThanOrEqualTo(String value) {
            addCriterion("COUPON_TAB <=", value, "couponTab");
            return (Criteria) this;
        }

        public Criteria andCouponTabLike(String value) {
            addCriterion("COUPON_TAB like", value, "couponTab");
            return (Criteria) this;
        }

        public Criteria andCouponTabNotLike(String value) {
            addCriterion("COUPON_TAB not like", value, "couponTab");
            return (Criteria) this;
        }

        public Criteria andCouponTabIn(List<String> values) {
            addCriterion("COUPON_TAB in", values, "couponTab");
            return (Criteria) this;
        }

        public Criteria andCouponTabNotIn(List<String> values) {
            addCriterion("COUPON_TAB not in", values, "couponTab");
            return (Criteria) this;
        }

        public Criteria andCouponTabBetween(String value1, String value2) {
            addCriterion("COUPON_TAB between", value1, value2, "couponTab");
            return (Criteria) this;
        }

        public Criteria andCouponTabNotBetween(String value1, String value2) {
            addCriterion("COUPON_TAB not between", value1, value2, "couponTab");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceIsNull() {
            addCriterion("DISCOUNT_PRICE is null");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceIsNotNull() {
            addCriterion("DISCOUNT_PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceEqualTo(Double value) {
            addCriterion("DISCOUNT_PRICE =", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotEqualTo(Double value) {
            addCriterion("DISCOUNT_PRICE <>", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceGreaterThan(Double value) {
            addCriterion("DISCOUNT_PRICE >", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("DISCOUNT_PRICE >=", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceLessThan(Double value) {
            addCriterion("DISCOUNT_PRICE <", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceLessThanOrEqualTo(Double value) {
            addCriterion("DISCOUNT_PRICE <=", value, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceIn(List<Double> values) {
            addCriterion("DISCOUNT_PRICE in", values, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotIn(List<Double> values) {
            addCriterion("DISCOUNT_PRICE not in", values, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceBetween(Double value1, Double value2) {
            addCriterion("DISCOUNT_PRICE between", value1, value2, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountPriceNotBetween(Double value1, Double value2) {
            addCriterion("DISCOUNT_PRICE not between", value1, value2, "discountPrice");
            return (Criteria) this;
        }

        public Criteria andDiscountRateIsNull() {
            addCriterion("DISCOUNT_RATE is null");
            return (Criteria) this;
        }

        public Criteria andDiscountRateIsNotNull() {
            addCriterion("DISCOUNT_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountRateEqualTo(Double value) {
            addCriterion("DISCOUNT_RATE =", value, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateNotEqualTo(Double value) {
            addCriterion("DISCOUNT_RATE <>", value, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateGreaterThan(Double value) {
            addCriterion("DISCOUNT_RATE >", value, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateGreaterThanOrEqualTo(Double value) {
            addCriterion("DISCOUNT_RATE >=", value, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateLessThan(Double value) {
            addCriterion("DISCOUNT_RATE <", value, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateLessThanOrEqualTo(Double value) {
            addCriterion("DISCOUNT_RATE <=", value, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateIn(List<Double> values) {
            addCriterion("DISCOUNT_RATE in", values, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateNotIn(List<Double> values) {
            addCriterion("DISCOUNT_RATE not in", values, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateBetween(Double value1, Double value2) {
            addCriterion("DISCOUNT_RATE between", value1, value2, "discountRate");
            return (Criteria) this;
        }

        public Criteria andDiscountRateNotBetween(Double value1, Double value2) {
            addCriterion("DISCOUNT_RATE not between", value1, value2, "discountRate");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNull() {
            addCriterion("END_TIME is null");
            return (Criteria) this;
        }

        public Criteria andEndTimeIsNotNull() {
            addCriterion("END_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andEndTimeEqualTo(Date value) {
            addCriterion("END_TIME =", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotEqualTo(Date value) {
            addCriterion("END_TIME <>", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThan(Date value) {
            addCriterion("END_TIME >", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("END_TIME >=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThan(Date value) {
            addCriterion("END_TIME <", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("END_TIME <=", value, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeIn(List<Date> values) {
            addCriterion("END_TIME in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotIn(List<Date> values) {
            addCriterion("END_TIME not in", values, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeBetween(Date value1, Date value2) {
            addCriterion("END_TIME between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("END_TIME not between", value1, value2, "endTime");
            return (Criteria) this;
        }

        public Criteria andExPriceIsNull() {
            addCriterion("EX_PRICE is null");
            return (Criteria) this;
        }

        public Criteria andExPriceIsNotNull() {
            addCriterion("EX_PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andExPriceEqualTo(Double value) {
            addCriterion("EX_PRICE =", value, "exPrice");
            return (Criteria) this;
        }

        public Criteria andExPriceNotEqualTo(Double value) {
            addCriterion("EX_PRICE <>", value, "exPrice");
            return (Criteria) this;
        }

        public Criteria andExPriceGreaterThan(Double value) {
            addCriterion("EX_PRICE >", value, "exPrice");
            return (Criteria) this;
        }

        public Criteria andExPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("EX_PRICE >=", value, "exPrice");
            return (Criteria) this;
        }

        public Criteria andExPriceLessThan(Double value) {
            addCriterion("EX_PRICE <", value, "exPrice");
            return (Criteria) this;
        }

        public Criteria andExPriceLessThanOrEqualTo(Double value) {
            addCriterion("EX_PRICE <=", value, "exPrice");
            return (Criteria) this;
        }

        public Criteria andExPriceIn(List<Double> values) {
            addCriterion("EX_PRICE in", values, "exPrice");
            return (Criteria) this;
        }

        public Criteria andExPriceNotIn(List<Double> values) {
            addCriterion("EX_PRICE not in", values, "exPrice");
            return (Criteria) this;
        }

        public Criteria andExPriceBetween(Double value1, Double value2) {
            addCriterion("EX_PRICE between", value1, value2, "exPrice");
            return (Criteria) this;
        }

        public Criteria andExPriceNotBetween(Double value1, Double value2) {
            addCriterion("EX_PRICE not between", value1, value2, "exPrice");
            return (Criteria) this;
        }

        public Criteria andImgUrlIsNull() {
            addCriterion("IMG_URL is null");
            return (Criteria) this;
        }

        public Criteria andImgUrlIsNotNull() {
            addCriterion("IMG_URL is not null");
            return (Criteria) this;
        }

        public Criteria andImgUrlEqualTo(String value) {
            addCriterion("IMG_URL =", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlNotEqualTo(String value) {
            addCriterion("IMG_URL <>", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlGreaterThan(String value) {
            addCriterion("IMG_URL >", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlGreaterThanOrEqualTo(String value) {
            addCriterion("IMG_URL >=", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlLessThan(String value) {
            addCriterion("IMG_URL <", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlLessThanOrEqualTo(String value) {
            addCriterion("IMG_URL <=", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlLike(String value) {
            addCriterion("IMG_URL like", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlNotLike(String value) {
            addCriterion("IMG_URL not like", value, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlIn(List<String> values) {
            addCriterion("IMG_URL in", values, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlNotIn(List<String> values) {
            addCriterion("IMG_URL not in", values, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlBetween(String value1, String value2) {
            addCriterion("IMG_URL between", value1, value2, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andImgUrlNotBetween(String value1, String value2) {
            addCriterion("IMG_URL not between", value1, value2, "imgUrl");
            return (Criteria) this;
        }

        public Criteria andInOrderCommIsNull() {
            addCriterion("IN_ORDER_COMM is null");
            return (Criteria) this;
        }

        public Criteria andInOrderCommIsNotNull() {
            addCriterion("IN_ORDER_COMM is not null");
            return (Criteria) this;
        }

        public Criteria andInOrderCommEqualTo(Double value) {
            addCriterion("IN_ORDER_COMM =", value, "inOrderComm");
            return (Criteria) this;
        }

        public Criteria andInOrderCommNotEqualTo(Double value) {
            addCriterion("IN_ORDER_COMM <>", value, "inOrderComm");
            return (Criteria) this;
        }

        public Criteria andInOrderCommGreaterThan(Double value) {
            addCriterion("IN_ORDER_COMM >", value, "inOrderComm");
            return (Criteria) this;
        }

        public Criteria andInOrderCommGreaterThanOrEqualTo(Double value) {
            addCriterion("IN_ORDER_COMM >=", value, "inOrderComm");
            return (Criteria) this;
        }

        public Criteria andInOrderCommLessThan(Double value) {
            addCriterion("IN_ORDER_COMM <", value, "inOrderComm");
            return (Criteria) this;
        }

        public Criteria andInOrderCommLessThanOrEqualTo(Double value) {
            addCriterion("IN_ORDER_COMM <=", value, "inOrderComm");
            return (Criteria) this;
        }

        public Criteria andInOrderCommIn(List<Double> values) {
            addCriterion("IN_ORDER_COMM in", values, "inOrderComm");
            return (Criteria) this;
        }

        public Criteria andInOrderCommNotIn(List<Double> values) {
            addCriterion("IN_ORDER_COMM not in", values, "inOrderComm");
            return (Criteria) this;
        }

        public Criteria andInOrderCommBetween(Double value1, Double value2) {
            addCriterion("IN_ORDER_COMM between", value1, value2, "inOrderComm");
            return (Criteria) this;
        }

        public Criteria andInOrderCommNotBetween(Double value1, Double value2) {
            addCriterion("IN_ORDER_COMM not between", value1, value2, "inOrderComm");
            return (Criteria) this;
        }

        public Criteria andInOrderCountIsNull() {
            addCriterion("IN_ORDER_COUNT is null");
            return (Criteria) this;
        }

        public Criteria andInOrderCountIsNotNull() {
            addCriterion("IN_ORDER_COUNT is not null");
            return (Criteria) this;
        }

        public Criteria andInOrderCountEqualTo(Double value) {
            addCriterion("IN_ORDER_COUNT =", value, "inOrderCount");
            return (Criteria) this;
        }

        public Criteria andInOrderCountNotEqualTo(Double value) {
            addCriterion("IN_ORDER_COUNT <>", value, "inOrderCount");
            return (Criteria) this;
        }

        public Criteria andInOrderCountGreaterThan(Double value) {
            addCriterion("IN_ORDER_COUNT >", value, "inOrderCount");
            return (Criteria) this;
        }

        public Criteria andInOrderCountGreaterThanOrEqualTo(Double value) {
            addCriterion("IN_ORDER_COUNT >=", value, "inOrderCount");
            return (Criteria) this;
        }

        public Criteria andInOrderCountLessThan(Double value) {
            addCriterion("IN_ORDER_COUNT <", value, "inOrderCount");
            return (Criteria) this;
        }

        public Criteria andInOrderCountLessThanOrEqualTo(Double value) {
            addCriterion("IN_ORDER_COUNT <=", value, "inOrderCount");
            return (Criteria) this;
        }

        public Criteria andInOrderCountIn(List<Double> values) {
            addCriterion("IN_ORDER_COUNT in", values, "inOrderCount");
            return (Criteria) this;
        }

        public Criteria andInOrderCountNotIn(List<Double> values) {
            addCriterion("IN_ORDER_COUNT not in", values, "inOrderCount");
            return (Criteria) this;
        }

        public Criteria andInOrderCountBetween(Double value1, Double value2) {
            addCriterion("IN_ORDER_COUNT between", value1, value2, "inOrderCount");
            return (Criteria) this;
        }

        public Criteria andInOrderCountNotBetween(Double value1, Double value2) {
            addCriterion("IN_ORDER_COUNT not between", value1, value2, "inOrderCount");
            return (Criteria) this;
        }

        public Criteria andIsLockIsNull() {
            addCriterion("IS_LOCK is null");
            return (Criteria) this;
        }

        public Criteria andIsLockIsNotNull() {
            addCriterion("IS_LOCK is not null");
            return (Criteria) this;
        }

        public Criteria andIsLockEqualTo(String value) {
            addCriterion("IS_LOCK =", value, "isLock");
            return (Criteria) this;
        }

        public Criteria andIsLockNotEqualTo(String value) {
            addCriterion("IS_LOCK <>", value, "isLock");
            return (Criteria) this;
        }

        public Criteria andIsLockGreaterThan(String value) {
            addCriterion("IS_LOCK >", value, "isLock");
            return (Criteria) this;
        }

        public Criteria andIsLockGreaterThanOrEqualTo(String value) {
            addCriterion("IS_LOCK >=", value, "isLock");
            return (Criteria) this;
        }

        public Criteria andIsLockLessThan(String value) {
            addCriterion("IS_LOCK <", value, "isLock");
            return (Criteria) this;
        }

        public Criteria andIsLockLessThanOrEqualTo(String value) {
            addCriterion("IS_LOCK <=", value, "isLock");
            return (Criteria) this;
        }

        public Criteria andIsLockLike(String value) {
            addCriterion("IS_LOCK like", value, "isLock");
            return (Criteria) this;
        }

        public Criteria andIsLockNotLike(String value) {
            addCriterion("IS_LOCK not like", value, "isLock");
            return (Criteria) this;
        }

        public Criteria andIsLockIn(List<String> values) {
            addCriterion("IS_LOCK in", values, "isLock");
            return (Criteria) this;
        }

        public Criteria andIsLockNotIn(List<String> values) {
            addCriterion("IS_LOCK not in", values, "isLock");
            return (Criteria) this;
        }

        public Criteria andIsLockBetween(String value1, String value2) {
            addCriterion("IS_LOCK between", value1, value2, "isLock");
            return (Criteria) this;
        }

        public Criteria andIsLockNotBetween(String value1, String value2) {
            addCriterion("IS_LOCK not between", value1, value2, "isLock");
            return (Criteria) this;
        }

        public Criteria andIsPlanIsNull() {
            addCriterion("IS_PLAN is null");
            return (Criteria) this;
        }

        public Criteria andIsPlanIsNotNull() {
            addCriterion("IS_PLAN is not null");
            return (Criteria) this;
        }

        public Criteria andIsPlanEqualTo(String value) {
            addCriterion("IS_PLAN =", value, "isPlan");
            return (Criteria) this;
        }

        public Criteria andIsPlanNotEqualTo(String value) {
            addCriterion("IS_PLAN <>", value, "isPlan");
            return (Criteria) this;
        }

        public Criteria andIsPlanGreaterThan(String value) {
            addCriterion("IS_PLAN >", value, "isPlan");
            return (Criteria) this;
        }

        public Criteria andIsPlanGreaterThanOrEqualTo(String value) {
            addCriterion("IS_PLAN >=", value, "isPlan");
            return (Criteria) this;
        }

        public Criteria andIsPlanLessThan(String value) {
            addCriterion("IS_PLAN <", value, "isPlan");
            return (Criteria) this;
        }

        public Criteria andIsPlanLessThanOrEqualTo(String value) {
            addCriterion("IS_PLAN <=", value, "isPlan");
            return (Criteria) this;
        }

        public Criteria andIsPlanLike(String value) {
            addCriterion("IS_PLAN like", value, "isPlan");
            return (Criteria) this;
        }

        public Criteria andIsPlanNotLike(String value) {
            addCriterion("IS_PLAN not like", value, "isPlan");
            return (Criteria) this;
        }

        public Criteria andIsPlanIn(List<String> values) {
            addCriterion("IS_PLAN in", values, "isPlan");
            return (Criteria) this;
        }

        public Criteria andIsPlanNotIn(List<String> values) {
            addCriterion("IS_PLAN not in", values, "isPlan");
            return (Criteria) this;
        }

        public Criteria andIsPlanBetween(String value1, String value2) {
            addCriterion("IS_PLAN between", value1, value2, "isPlan");
            return (Criteria) this;
        }

        public Criteria andIsPlanNotBetween(String value1, String value2) {
            addCriterion("IS_PLAN not between", value1, value2, "isPlan");
            return (Criteria) this;
        }

        public Criteria andManJianNoteIsNull() {
            addCriterion("MAN_JIAN_NOTE is null");
            return (Criteria) this;
        }

        public Criteria andManJianNoteIsNotNull() {
            addCriterion("MAN_JIAN_NOTE is not null");
            return (Criteria) this;
        }

        public Criteria andManJianNoteEqualTo(String value) {
            addCriterion("MAN_JIAN_NOTE =", value, "manJianNote");
            return (Criteria) this;
        }

        public Criteria andManJianNoteNotEqualTo(String value) {
            addCriterion("MAN_JIAN_NOTE <>", value, "manJianNote");
            return (Criteria) this;
        }

        public Criteria andManJianNoteGreaterThan(String value) {
            addCriterion("MAN_JIAN_NOTE >", value, "manJianNote");
            return (Criteria) this;
        }

        public Criteria andManJianNoteGreaterThanOrEqualTo(String value) {
            addCriterion("MAN_JIAN_NOTE >=", value, "manJianNote");
            return (Criteria) this;
        }

        public Criteria andManJianNoteLessThan(String value) {
            addCriterion("MAN_JIAN_NOTE <", value, "manJianNote");
            return (Criteria) this;
        }

        public Criteria andManJianNoteLessThanOrEqualTo(String value) {
            addCriterion("MAN_JIAN_NOTE <=", value, "manJianNote");
            return (Criteria) this;
        }

        public Criteria andManJianNoteLike(String value) {
            addCriterion("MAN_JIAN_NOTE like", value, "manJianNote");
            return (Criteria) this;
        }

        public Criteria andManJianNoteNotLike(String value) {
            addCriterion("MAN_JIAN_NOTE not like", value, "manJianNote");
            return (Criteria) this;
        }

        public Criteria andManJianNoteIn(List<String> values) {
            addCriterion("MAN_JIAN_NOTE in", values, "manJianNote");
            return (Criteria) this;
        }

        public Criteria andManJianNoteNotIn(List<String> values) {
            addCriterion("MAN_JIAN_NOTE not in", values, "manJianNote");
            return (Criteria) this;
        }

        public Criteria andManJianNoteBetween(String value1, String value2) {
            addCriterion("MAN_JIAN_NOTE between", value1, value2, "manJianNote");
            return (Criteria) this;
        }

        public Criteria andManJianNoteNotBetween(String value1, String value2) {
            addCriterion("MAN_JIAN_NOTE not between", value1, value2, "manJianNote");
            return (Criteria) this;
        }

        public Criteria andPcCommissionIsNull() {
            addCriterion("PC_COMMISSION is null");
            return (Criteria) this;
        }

        public Criteria andPcCommissionIsNotNull() {
            addCriterion("PC_COMMISSION is not null");
            return (Criteria) this;
        }

        public Criteria andPcCommissionEqualTo(Double value) {
            addCriterion("PC_COMMISSION =", value, "pcCommission");
            return (Criteria) this;
        }

        public Criteria andPcCommissionNotEqualTo(Double value) {
            addCriterion("PC_COMMISSION <>", value, "pcCommission");
            return (Criteria) this;
        }

        public Criteria andPcCommissionGreaterThan(Double value) {
            addCriterion("PC_COMMISSION >", value, "pcCommission");
            return (Criteria) this;
        }

        public Criteria andPcCommissionGreaterThanOrEqualTo(Double value) {
            addCriterion("PC_COMMISSION >=", value, "pcCommission");
            return (Criteria) this;
        }

        public Criteria andPcCommissionLessThan(Double value) {
            addCriterion("PC_COMMISSION <", value, "pcCommission");
            return (Criteria) this;
        }

        public Criteria andPcCommissionLessThanOrEqualTo(Double value) {
            addCriterion("PC_COMMISSION <=", value, "pcCommission");
            return (Criteria) this;
        }

        public Criteria andPcCommissionIn(List<Double> values) {
            addCriterion("PC_COMMISSION in", values, "pcCommission");
            return (Criteria) this;
        }

        public Criteria andPcCommissionNotIn(List<Double> values) {
            addCriterion("PC_COMMISSION not in", values, "pcCommission");
            return (Criteria) this;
        }

        public Criteria andPcCommissionBetween(Double value1, Double value2) {
            addCriterion("PC_COMMISSION between", value1, value2, "pcCommission");
            return (Criteria) this;
        }

        public Criteria andPcCommissionNotBetween(Double value1, Double value2) {
            addCriterion("PC_COMMISSION not between", value1, value2, "pcCommission");
            return (Criteria) this;
        }

        public Criteria andPcCommissionShareIsNull() {
            addCriterion("PC_COMMISSION_SHARE is null");
            return (Criteria) this;
        }

        public Criteria andPcCommissionShareIsNotNull() {
            addCriterion("PC_COMMISSION_SHARE is not null");
            return (Criteria) this;
        }

        public Criteria andPcCommissionShareEqualTo(Double value) {
            addCriterion("PC_COMMISSION_SHARE =", value, "pcCommissionShare");
            return (Criteria) this;
        }

        public Criteria andPcCommissionShareNotEqualTo(Double value) {
            addCriterion("PC_COMMISSION_SHARE <>", value, "pcCommissionShare");
            return (Criteria) this;
        }

        public Criteria andPcCommissionShareGreaterThan(Double value) {
            addCriterion("PC_COMMISSION_SHARE >", value, "pcCommissionShare");
            return (Criteria) this;
        }

        public Criteria andPcCommissionShareGreaterThanOrEqualTo(Double value) {
            addCriterion("PC_COMMISSION_SHARE >=", value, "pcCommissionShare");
            return (Criteria) this;
        }

        public Criteria andPcCommissionShareLessThan(Double value) {
            addCriterion("PC_COMMISSION_SHARE <", value, "pcCommissionShare");
            return (Criteria) this;
        }

        public Criteria andPcCommissionShareLessThanOrEqualTo(Double value) {
            addCriterion("PC_COMMISSION_SHARE <=", value, "pcCommissionShare");
            return (Criteria) this;
        }

        public Criteria andPcCommissionShareIn(List<Double> values) {
            addCriterion("PC_COMMISSION_SHARE in", values, "pcCommissionShare");
            return (Criteria) this;
        }

        public Criteria andPcCommissionShareNotIn(List<Double> values) {
            addCriterion("PC_COMMISSION_SHARE not in", values, "pcCommissionShare");
            return (Criteria) this;
        }

        public Criteria andPcCommissionShareBetween(Double value1, Double value2) {
            addCriterion("PC_COMMISSION_SHARE between", value1, value2, "pcCommissionShare");
            return (Criteria) this;
        }

        public Criteria andPcCommissionShareNotBetween(Double value1, Double value2) {
            addCriterion("PC_COMMISSION_SHARE not between", value1, value2, "pcCommissionShare");
            return (Criteria) this;
        }

        public Criteria andPcPriceIsNull() {
            addCriterion("PC_PRICE is null");
            return (Criteria) this;
        }

        public Criteria andPcPriceIsNotNull() {
            addCriterion("PC_PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andPcPriceEqualTo(Double value) {
            addCriterion("PC_PRICE =", value, "pcPrice");
            return (Criteria) this;
        }

        public Criteria andPcPriceNotEqualTo(Double value) {
            addCriterion("PC_PRICE <>", value, "pcPrice");
            return (Criteria) this;
        }

        public Criteria andPcPriceGreaterThan(Double value) {
            addCriterion("PC_PRICE >", value, "pcPrice");
            return (Criteria) this;
        }

        public Criteria andPcPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("PC_PRICE >=", value, "pcPrice");
            return (Criteria) this;
        }

        public Criteria andPcPriceLessThan(Double value) {
            addCriterion("PC_PRICE <", value, "pcPrice");
            return (Criteria) this;
        }

        public Criteria andPcPriceLessThanOrEqualTo(Double value) {
            addCriterion("PC_PRICE <=", value, "pcPrice");
            return (Criteria) this;
        }

        public Criteria andPcPriceIn(List<Double> values) {
            addCriterion("PC_PRICE in", values, "pcPrice");
            return (Criteria) this;
        }

        public Criteria andPcPriceNotIn(List<Double> values) {
            addCriterion("PC_PRICE not in", values, "pcPrice");
            return (Criteria) this;
        }

        public Criteria andPcPriceBetween(Double value1, Double value2) {
            addCriterion("PC_PRICE between", value1, value2, "pcPrice");
            return (Criteria) this;
        }

        public Criteria andPcPriceNotBetween(Double value1, Double value2) {
            addCriterion("PC_PRICE not between", value1, value2, "pcPrice");
            return (Criteria) this;
        }

        public Criteria andPlanIsNull() {
            addCriterion("PLAN is null");
            return (Criteria) this;
        }

        public Criteria andPlanIsNotNull() {
            addCriterion("PLAN is not null");
            return (Criteria) this;
        }

        public Criteria andPlanEqualTo(String value) {
            addCriterion("PLAN =", value, "plan");
            return (Criteria) this;
        }

        public Criteria andPlanNotEqualTo(String value) {
            addCriterion("PLAN <>", value, "plan");
            return (Criteria) this;
        }

        public Criteria andPlanGreaterThan(String value) {
            addCriterion("PLAN >", value, "plan");
            return (Criteria) this;
        }

        public Criteria andPlanGreaterThanOrEqualTo(String value) {
            addCriterion("PLAN >=", value, "plan");
            return (Criteria) this;
        }

        public Criteria andPlanLessThan(String value) {
            addCriterion("PLAN <", value, "plan");
            return (Criteria) this;
        }

        public Criteria andPlanLessThanOrEqualTo(String value) {
            addCriterion("PLAN <=", value, "plan");
            return (Criteria) this;
        }

        public Criteria andPlanLike(String value) {
            addCriterion("PLAN like", value, "plan");
            return (Criteria) this;
        }

        public Criteria andPlanNotLike(String value) {
            addCriterion("PLAN not like", value, "plan");
            return (Criteria) this;
        }

        public Criteria andPlanIn(List<String> values) {
            addCriterion("PLAN in", values, "plan");
            return (Criteria) this;
        }

        public Criteria andPlanNotIn(List<String> values) {
            addCriterion("PLAN not in", values, "plan");
            return (Criteria) this;
        }

        public Criteria andPlanBetween(String value1, String value2) {
            addCriterion("PLAN between", value1, value2, "plan");
            return (Criteria) this;
        }

        public Criteria andPlanNotBetween(String value1, String value2) {
            addCriterion("PLAN not between", value1, value2, "plan");
            return (Criteria) this;
        }

        public Criteria andPrmTabIsNull() {
            addCriterion("PRM_TAB is null");
            return (Criteria) this;
        }

        public Criteria andPrmTabIsNotNull() {
            addCriterion("PRM_TAB is not null");
            return (Criteria) this;
        }

        public Criteria andPrmTabEqualTo(String value) {
            addCriterion("PRM_TAB =", value, "prmTab");
            return (Criteria) this;
        }

        public Criteria andPrmTabNotEqualTo(String value) {
            addCriterion("PRM_TAB <>", value, "prmTab");
            return (Criteria) this;
        }

        public Criteria andPrmTabGreaterThan(String value) {
            addCriterion("PRM_TAB >", value, "prmTab");
            return (Criteria) this;
        }

        public Criteria andPrmTabGreaterThanOrEqualTo(String value) {
            addCriterion("PRM_TAB >=", value, "prmTab");
            return (Criteria) this;
        }

        public Criteria andPrmTabLessThan(String value) {
            addCriterion("PRM_TAB <", value, "prmTab");
            return (Criteria) this;
        }

        public Criteria andPrmTabLessThanOrEqualTo(String value) {
            addCriterion("PRM_TAB <=", value, "prmTab");
            return (Criteria) this;
        }

        public Criteria andPrmTabLike(String value) {
            addCriterion("PRM_TAB like", value, "prmTab");
            return (Criteria) this;
        }

        public Criteria andPrmTabNotLike(String value) {
            addCriterion("PRM_TAB not like", value, "prmTab");
            return (Criteria) this;
        }

        public Criteria andPrmTabIn(List<String> values) {
            addCriterion("PRM_TAB in", values, "prmTab");
            return (Criteria) this;
        }

        public Criteria andPrmTabNotIn(List<String> values) {
            addCriterion("PRM_TAB not in", values, "prmTab");
            return (Criteria) this;
        }

        public Criteria andPrmTabBetween(String value1, String value2) {
            addCriterion("PRM_TAB between", value1, value2, "prmTab");
            return (Criteria) this;
        }

        public Criteria andPrmTabNotBetween(String value1, String value2) {
            addCriterion("PRM_TAB not between", value1, value2, "prmTab");
            return (Criteria) this;
        }

        public Criteria andRealRateIsNull() {
            addCriterion("REAL_RATE is null");
            return (Criteria) this;
        }

        public Criteria andRealRateIsNotNull() {
            addCriterion("REAL_RATE is not null");
            return (Criteria) this;
        }

        public Criteria andRealRateEqualTo(String value) {
            addCriterion("REAL_RATE =", value, "realRate");
            return (Criteria) this;
        }

        public Criteria andRealRateNotEqualTo(String value) {
            addCriterion("REAL_RATE <>", value, "realRate");
            return (Criteria) this;
        }

        public Criteria andRealRateGreaterThan(String value) {
            addCriterion("REAL_RATE >", value, "realRate");
            return (Criteria) this;
        }

        public Criteria andRealRateGreaterThanOrEqualTo(String value) {
            addCriterion("REAL_RATE >=", value, "realRate");
            return (Criteria) this;
        }

        public Criteria andRealRateLessThan(String value) {
            addCriterion("REAL_RATE <", value, "realRate");
            return (Criteria) this;
        }

        public Criteria andRealRateLessThanOrEqualTo(String value) {
            addCriterion("REAL_RATE <=", value, "realRate");
            return (Criteria) this;
        }

        public Criteria andRealRateLike(String value) {
            addCriterion("REAL_RATE like", value, "realRate");
            return (Criteria) this;
        }

        public Criteria andRealRateNotLike(String value) {
            addCriterion("REAL_RATE not like", value, "realRate");
            return (Criteria) this;
        }

        public Criteria andRealRateIn(List<String> values) {
            addCriterion("REAL_RATE in", values, "realRate");
            return (Criteria) this;
        }

        public Criteria andRealRateNotIn(List<String> values) {
            addCriterion("REAL_RATE not in", values, "realRate");
            return (Criteria) this;
        }

        public Criteria andRealRateBetween(String value1, String value2) {
            addCriterion("REAL_RATE between", value1, value2, "realRate");
            return (Criteria) this;
        }

        public Criteria andRealRateNotBetween(String value1, String value2) {
            addCriterion("REAL_RATE not between", value1, value2, "realRate");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNull() {
            addCriterion("SHOP_NAME is null");
            return (Criteria) this;
        }

        public Criteria andShopNameIsNotNull() {
            addCriterion("SHOP_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andShopNameEqualTo(String value) {
            addCriterion("SHOP_NAME =", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotEqualTo(String value) {
            addCriterion("SHOP_NAME <>", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThan(String value) {
            addCriterion("SHOP_NAME >", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameGreaterThanOrEqualTo(String value) {
            addCriterion("SHOP_NAME >=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThan(String value) {
            addCriterion("SHOP_NAME <", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLessThanOrEqualTo(String value) {
            addCriterion("SHOP_NAME <=", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameLike(String value) {
            addCriterion("SHOP_NAME like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotLike(String value) {
            addCriterion("SHOP_NAME not like", value, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameIn(List<String> values) {
            addCriterion("SHOP_NAME in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotIn(List<String> values) {
            addCriterion("SHOP_NAME not in", values, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameBetween(String value1, String value2) {
            addCriterion("SHOP_NAME between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopNameNotBetween(String value1, String value2) {
            addCriterion("SHOP_NAME not between", value1, value2, "shopName");
            return (Criteria) this;
        }

        public Criteria andShopUrlIsNull() {
            addCriterion("SHOP_URL is null");
            return (Criteria) this;
        }

        public Criteria andShopUrlIsNotNull() {
            addCriterion("SHOP_URL is not null");
            return (Criteria) this;
        }

        public Criteria andShopUrlEqualTo(String value) {
            addCriterion("SHOP_URL =", value, "shopUrl");
            return (Criteria) this;
        }

        public Criteria andShopUrlNotEqualTo(String value) {
            addCriterion("SHOP_URL <>", value, "shopUrl");
            return (Criteria) this;
        }

        public Criteria andShopUrlGreaterThan(String value) {
            addCriterion("SHOP_URL >", value, "shopUrl");
            return (Criteria) this;
        }

        public Criteria andShopUrlGreaterThanOrEqualTo(String value) {
            addCriterion("SHOP_URL >=", value, "shopUrl");
            return (Criteria) this;
        }

        public Criteria andShopUrlLessThan(String value) {
            addCriterion("SHOP_URL <", value, "shopUrl");
            return (Criteria) this;
        }

        public Criteria andShopUrlLessThanOrEqualTo(String value) {
            addCriterion("SHOP_URL <=", value, "shopUrl");
            return (Criteria) this;
        }

        public Criteria andShopUrlLike(String value) {
            addCriterion("SHOP_URL like", value, "shopUrl");
            return (Criteria) this;
        }

        public Criteria andShopUrlNotLike(String value) {
            addCriterion("SHOP_URL not like", value, "shopUrl");
            return (Criteria) this;
        }

        public Criteria andShopUrlIn(List<String> values) {
            addCriterion("SHOP_URL in", values, "shopUrl");
            return (Criteria) this;
        }

        public Criteria andShopUrlNotIn(List<String> values) {
            addCriterion("SHOP_URL not in", values, "shopUrl");
            return (Criteria) this;
        }

        public Criteria andShopUrlBetween(String value1, String value2) {
            addCriterion("SHOP_URL between", value1, value2, "shopUrl");
            return (Criteria) this;
        }

        public Criteria andShopUrlNotBetween(String value1, String value2) {
            addCriterion("SHOP_URL not between", value1, value2, "shopUrl");
            return (Criteria) this;
        }

        public Criteria andSkuIdIsNull() {
            addCriterion("SKU_ID is null");
            return (Criteria) this;
        }

        public Criteria andSkuIdIsNotNull() {
            addCriterion("SKU_ID is not null");
            return (Criteria) this;
        }

        public Criteria andSkuIdEqualTo(String value) {
            addCriterion("SKU_ID =", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdNotEqualTo(String value) {
            addCriterion("SKU_ID <>", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdGreaterThan(String value) {
            addCriterion("SKU_ID >", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdGreaterThanOrEqualTo(String value) {
            addCriterion("SKU_ID >=", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdLessThan(String value) {
            addCriterion("SKU_ID <", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdLessThanOrEqualTo(String value) {
            addCriterion("SKU_ID <=", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdLike(String value) {
            addCriterion("SKU_ID like", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdNotLike(String value) {
            addCriterion("SKU_ID not like", value, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdIn(List<String> values) {
            addCriterion("SKU_ID in", values, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdNotIn(List<String> values) {
            addCriterion("SKU_ID not in", values, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdBetween(String value1, String value2) {
            addCriterion("SKU_ID between", value1, value2, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuIdNotBetween(String value1, String value2) {
            addCriterion("SKU_ID not between", value1, value2, "skuId");
            return (Criteria) this;
        }

        public Criteria andSkuNameIsNull() {
            addCriterion("SKU_NAME is null");
            return (Criteria) this;
        }

        public Criteria andSkuNameIsNotNull() {
            addCriterion("SKU_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andSkuNameEqualTo(String value) {
            addCriterion("SKU_NAME =", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameNotEqualTo(String value) {
            addCriterion("SKU_NAME <>", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameGreaterThan(String value) {
            addCriterion("SKU_NAME >", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameGreaterThanOrEqualTo(String value) {
            addCriterion("SKU_NAME >=", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameLessThan(String value) {
            addCriterion("SKU_NAME <", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameLessThanOrEqualTo(String value) {
            addCriterion("SKU_NAME <=", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameLike(String value) {
            addCriterion("SKU_NAME like", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameNotLike(String value) {
            addCriterion("SKU_NAME not like", value, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameIn(List<String> values) {
            addCriterion("SKU_NAME in", values, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameNotIn(List<String> values) {
            addCriterion("SKU_NAME not in", values, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameBetween(String value1, String value2) {
            addCriterion("SKU_NAME between", value1, value2, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuNameNotBetween(String value1, String value2) {
            addCriterion("SKU_NAME not between", value1, value2, "skuName");
            return (Criteria) this;
        }

        public Criteria andSkuUrlIsNull() {
            addCriterion("SKU_URL is null");
            return (Criteria) this;
        }

        public Criteria andSkuUrlIsNotNull() {
            addCriterion("SKU_URL is not null");
            return (Criteria) this;
        }

        public Criteria andSkuUrlEqualTo(String value) {
            addCriterion("SKU_URL =", value, "skuUrl");
            return (Criteria) this;
        }

        public Criteria andSkuUrlNotEqualTo(String value) {
            addCriterion("SKU_URL <>", value, "skuUrl");
            return (Criteria) this;
        }

        public Criteria andSkuUrlGreaterThan(String value) {
            addCriterion("SKU_URL >", value, "skuUrl");
            return (Criteria) this;
        }

        public Criteria andSkuUrlGreaterThanOrEqualTo(String value) {
            addCriterion("SKU_URL >=", value, "skuUrl");
            return (Criteria) this;
        }

        public Criteria andSkuUrlLessThan(String value) {
            addCriterion("SKU_URL <", value, "skuUrl");
            return (Criteria) this;
        }

        public Criteria andSkuUrlLessThanOrEqualTo(String value) {
            addCriterion("SKU_URL <=", value, "skuUrl");
            return (Criteria) this;
        }

        public Criteria andSkuUrlLike(String value) {
            addCriterion("SKU_URL like", value, "skuUrl");
            return (Criteria) this;
        }

        public Criteria andSkuUrlNotLike(String value) {
            addCriterion("SKU_URL not like", value, "skuUrl");
            return (Criteria) this;
        }

        public Criteria andSkuUrlIn(List<String> values) {
            addCriterion("SKU_URL in", values, "skuUrl");
            return (Criteria) this;
        }

        public Criteria andSkuUrlNotIn(List<String> values) {
            addCriterion("SKU_URL not in", values, "skuUrl");
            return (Criteria) this;
        }

        public Criteria andSkuUrlBetween(String value1, String value2) {
            addCriterion("SKU_URL between", value1, value2, "skuUrl");
            return (Criteria) this;
        }

        public Criteria andSkuUrlNotBetween(String value1, String value2) {
            addCriterion("SKU_URL not between", value1, value2, "skuUrl");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNull() {
            addCriterion("START_TIME is null");
            return (Criteria) this;
        }

        public Criteria andStartTimeIsNotNull() {
            addCriterion("START_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andStartTimeEqualTo(Date value) {
            addCriterion("START_TIME =", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotEqualTo(Date value) {
            addCriterion("START_TIME <>", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThan(Date value) {
            addCriterion("START_TIME >", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("START_TIME >=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThan(Date value) {
            addCriterion("START_TIME <", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeLessThanOrEqualTo(Date value) {
            addCriterion("START_TIME <=", value, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeIn(List<Date> values) {
            addCriterion("START_TIME in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotIn(List<Date> values) {
            addCriterion("START_TIME not in", values, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeBetween(Date value1, Date value2) {
            addCriterion("START_TIME between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andStartTimeNotBetween(Date value1, Date value2) {
            addCriterion("START_TIME not between", value1, value2, "startTime");
            return (Criteria) this;
        }

        public Criteria andVidIsNull() {
            addCriterion("VID is null");
            return (Criteria) this;
        }

        public Criteria andVidIsNotNull() {
            addCriterion("VID is not null");
            return (Criteria) this;
        }

        public Criteria andVidEqualTo(String value) {
            addCriterion("VID =", value, "vid");
            return (Criteria) this;
        }

        public Criteria andVidNotEqualTo(String value) {
            addCriterion("VID <>", value, "vid");
            return (Criteria) this;
        }

        public Criteria andVidGreaterThan(String value) {
            addCriterion("VID >", value, "vid");
            return (Criteria) this;
        }

        public Criteria andVidGreaterThanOrEqualTo(String value) {
            addCriterion("VID >=", value, "vid");
            return (Criteria) this;
        }

        public Criteria andVidLessThan(String value) {
            addCriterion("VID <", value, "vid");
            return (Criteria) this;
        }

        public Criteria andVidLessThanOrEqualTo(String value) {
            addCriterion("VID <=", value, "vid");
            return (Criteria) this;
        }

        public Criteria andVidLike(String value) {
            addCriterion("VID like", value, "vid");
            return (Criteria) this;
        }

        public Criteria andVidNotLike(String value) {
            addCriterion("VID not like", value, "vid");
            return (Criteria) this;
        }

        public Criteria andVidIn(List<String> values) {
            addCriterion("VID in", values, "vid");
            return (Criteria) this;
        }

        public Criteria andVidNotIn(List<String> values) {
            addCriterion("VID not in", values, "vid");
            return (Criteria) this;
        }

        public Criteria andVidBetween(String value1, String value2) {
            addCriterion("VID between", value1, value2, "vid");
            return (Criteria) this;
        }

        public Criteria andVidNotBetween(String value1, String value2) {
            addCriterion("VID not between", value1, value2, "vid");
            return (Criteria) this;
        }

        public Criteria andWlCommissionIsNull() {
            addCriterion("WL_COMMISSION is null");
            return (Criteria) this;
        }

        public Criteria andWlCommissionIsNotNull() {
            addCriterion("WL_COMMISSION is not null");
            return (Criteria) this;
        }

        public Criteria andWlCommissionEqualTo(Double value) {
            addCriterion("WL_COMMISSION =", value, "wlCommission");
            return (Criteria) this;
        }

        public Criteria andWlCommissionNotEqualTo(Double value) {
            addCriterion("WL_COMMISSION <>", value, "wlCommission");
            return (Criteria) this;
        }

        public Criteria andWlCommissionGreaterThan(Double value) {
            addCriterion("WL_COMMISSION >", value, "wlCommission");
            return (Criteria) this;
        }

        public Criteria andWlCommissionGreaterThanOrEqualTo(Double value) {
            addCriterion("WL_COMMISSION >=", value, "wlCommission");
            return (Criteria) this;
        }

        public Criteria andWlCommissionLessThan(Double value) {
            addCriterion("WL_COMMISSION <", value, "wlCommission");
            return (Criteria) this;
        }

        public Criteria andWlCommissionLessThanOrEqualTo(Double value) {
            addCriterion("WL_COMMISSION <=", value, "wlCommission");
            return (Criteria) this;
        }

        public Criteria andWlCommissionIn(List<Double> values) {
            addCriterion("WL_COMMISSION in", values, "wlCommission");
            return (Criteria) this;
        }

        public Criteria andWlCommissionNotIn(List<Double> values) {
            addCriterion("WL_COMMISSION not in", values, "wlCommission");
            return (Criteria) this;
        }

        public Criteria andWlCommissionBetween(Double value1, Double value2) {
            addCriterion("WL_COMMISSION between", value1, value2, "wlCommission");
            return (Criteria) this;
        }

        public Criteria andWlCommissionNotBetween(Double value1, Double value2) {
            addCriterion("WL_COMMISSION not between", value1, value2, "wlCommission");
            return (Criteria) this;
        }

        public Criteria andWlCommissionShareIsNull() {
            addCriterion("WL_COMMISSION_SHARE is null");
            return (Criteria) this;
        }

        public Criteria andWlCommissionShareIsNotNull() {
            addCriterion("WL_COMMISSION_SHARE is not null");
            return (Criteria) this;
        }

        public Criteria andWlCommissionShareEqualTo(Double value) {
            addCriterion("WL_COMMISSION_SHARE =", value, "wlCommissionShare");
            return (Criteria) this;
        }

        public Criteria andWlCommissionShareNotEqualTo(Double value) {
            addCriterion("WL_COMMISSION_SHARE <>", value, "wlCommissionShare");
            return (Criteria) this;
        }

        public Criteria andWlCommissionShareGreaterThan(Double value) {
            addCriterion("WL_COMMISSION_SHARE >", value, "wlCommissionShare");
            return (Criteria) this;
        }

        public Criteria andWlCommissionShareGreaterThanOrEqualTo(Double value) {
            addCriterion("WL_COMMISSION_SHARE >=", value, "wlCommissionShare");
            return (Criteria) this;
        }

        public Criteria andWlCommissionShareLessThan(Double value) {
            addCriterion("WL_COMMISSION_SHARE <", value, "wlCommissionShare");
            return (Criteria) this;
        }

        public Criteria andWlCommissionShareLessThanOrEqualTo(Double value) {
            addCriterion("WL_COMMISSION_SHARE <=", value, "wlCommissionShare");
            return (Criteria) this;
        }

        public Criteria andWlCommissionShareIn(List<Double> values) {
            addCriterion("WL_COMMISSION_SHARE in", values, "wlCommissionShare");
            return (Criteria) this;
        }

        public Criteria andWlCommissionShareNotIn(List<Double> values) {
            addCriterion("WL_COMMISSION_SHARE not in", values, "wlCommissionShare");
            return (Criteria) this;
        }

        public Criteria andWlCommissionShareBetween(Double value1, Double value2) {
            addCriterion("WL_COMMISSION_SHARE between", value1, value2, "wlCommissionShare");
            return (Criteria) this;
        }

        public Criteria andWlCommissionShareNotBetween(Double value1, Double value2) {
            addCriterion("WL_COMMISSION_SHARE not between", value1, value2, "wlCommissionShare");
            return (Criteria) this;
        }

        public Criteria andWlPriceIsNull() {
            addCriterion("WL_PRICE is null");
            return (Criteria) this;
        }

        public Criteria andWlPriceIsNotNull() {
            addCriterion("WL_PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andWlPriceEqualTo(Double value) {
            addCriterion("WL_PRICE =", value, "wlPrice");
            return (Criteria) this;
        }

        public Criteria andWlPriceNotEqualTo(Double value) {
            addCriterion("WL_PRICE <>", value, "wlPrice");
            return (Criteria) this;
        }

        public Criteria andWlPriceGreaterThan(Double value) {
            addCriterion("WL_PRICE >", value, "wlPrice");
            return (Criteria) this;
        }

        public Criteria andWlPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("WL_PRICE >=", value, "wlPrice");
            return (Criteria) this;
        }

        public Criteria andWlPriceLessThan(Double value) {
            addCriterion("WL_PRICE <", value, "wlPrice");
            return (Criteria) this;
        }

        public Criteria andWlPriceLessThanOrEqualTo(Double value) {
            addCriterion("WL_PRICE <=", value, "wlPrice");
            return (Criteria) this;
        }

        public Criteria andWlPriceIn(List<Double> values) {
            addCriterion("WL_PRICE in", values, "wlPrice");
            return (Criteria) this;
        }

        public Criteria andWlPriceNotIn(List<Double> values) {
            addCriterion("WL_PRICE not in", values, "wlPrice");
            return (Criteria) this;
        }

        public Criteria andWlPriceBetween(Double value1, Double value2) {
            addCriterion("WL_PRICE between", value1, value2, "wlPrice");
            return (Criteria) this;
        }

        public Criteria andWlPriceNotBetween(Double value1, Double value2) {
            addCriterion("WL_PRICE not between", value1, value2, "wlPrice");
            return (Criteria) this;
        }
    }

    /**
     * This class corresponds to the database table t_goods_hot_jd
     *
     * @mbggenerated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * This class corresponds to the database table t_goods_hot_jd
     *
     * @mbggenerated
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value) {
            super();
            this.condition = condition;
            this.value = value;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.betweenValue = true;
        }
    }
}